﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Manage/ManageMasterPage.master" AutoEventWireup="true" CodeFile="SelectOne.aspx.cs" Inherits="Manage_SelectOne" Theme="主题1"%>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <div style="margin: 0px auto; width: 100%; text-align:center;background-color:#f3f9eb;" >
        <asp:Label ID="Label1" runat="server" Text="查询订单号："></asp:Label>
        <asp:TextBox ID="OnoTex" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" />
    </div>
    <div style="margin: 0px auto; width: 100%; text-align:center;background-color:#f3f9eb;padding-bottom:100px" >
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Ono" DataSourceID="SqlDataSource1" CssClass="mGrid">
            <Columns>
                <asp:BoundField DataField="Ono" HeaderText="Ono" ReadOnly="True" SortExpression="Ono" />
                <asp:BoundField DataField="Oname" HeaderText="Oname" SortExpression="Oname" />
                <asp:BoundField DataField="Ophone" HeaderText="Ophone" SortExpression="Ophone" />
                <asp:BoundField DataField="Oadr" HeaderText="Oadr" SortExpression="Oadr" />
                <asp:BoundField DataField="Opayway" HeaderText="Opayway" SortExpression="Opayway" />
                <asp:CheckBoxField DataField="Opaystate" HeaderText="Opaystate" SortExpression="Opaystate" />
                <asp:BoundField DataField="Sno" HeaderText="Sno" SortExpression="Sno" />
                <asp:BoundField DataField="Osendtime" HeaderText="Osendtime" SortExpression="Osendtime" />
                <asp:BoundField DataField="Osumprice" HeaderText="Osumprice" SortExpression="Osumprice" />
                <asp:BoundField DataField="Ostate" HeaderText="Ostate" SortExpression="Ostate" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=SUBAI-WORKSTATI;Initial Catalog=Restaurant;Persist Security Info=True;User ID=Manager;Password=321" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Ono], [Oname], [Ophone], [Oadr], [Opayway], [Opaystate], [Sno], [Osendtime], [Osumprice], [Ostate] FROM [Manager_Order] WHERE ([Ono] = @Ono)" >
            <SelectParameters>
                <asp:ControlParameter ControlID="OnoTex" Name="Ono" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
                    <br>
        <div style="width:60%;margin:0 auto;text-align:center">
            <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" CssClass="mGrid">
                <Columns>
                    <asp:BoundField DataField="Dname" HeaderText="Dname" SortExpression="Dname" />
                    <asp:BoundField DataField="Dprice" HeaderText="Dprice" SortExpression="Dprice" />
                    <asp:BoundField DataField="Dclass" HeaderText="Dclass" SortExpression="Dclass" />
                    <asp:BoundField DataField="Cnum" HeaderText="Cnum" SortExpression="Cnum" />
                    <asp:BoundField DataField="Cremarks" HeaderText="Cremarks" SortExpression="Cremarks" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=SUBAI-WORKSTATI;Initial Catalog=Restaurant;Persist Security Info=True;User ID=Manager;Password=321" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Dname], [Dprice], [Dclass], [Cnum], [Cremarks] FROM [Manager_ViewOrder] WHERE ([Ono] = @Ono)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="OnoTex" Name="Ono" PropertyName="Text" Type="String" />
                </SelectParameters>
            </asp:SqlDataSource>
        </div>
    </div>
</asp:Content>

